|
Book details / order |
EXCEL HACKS, 2ND EDITION |
How do you take advantage of excel's advanced capabilities without spending hours studying it? excel hacks provides more than 130 hacks clever tools, tips, and techniques that will make you a true excel power user.
this resourceful, roll-up-your-sleeves guide gives you little-known "backdoor" tricks for several excel versions including excel 2007 using different platforms and external applications. think of this book as a toolbox. when a need arises, you can simply use the right tool for the job. hacks are grouped into chapters so you can find what you need quickly, including ways to:
* reduce workbook and worksheet frustration manage how users interact with worksheets, find and highlight information, and deal with debris and corruption
* analyze and manage data extend and automate these features, moving beyond the limited tasks they were designed to perform
* hack names learn how to name cells and ranges, and create names that adapt to the data in your spreadsheet
* get more out of pivottables and avoid problems with them
* create customized charts by tweaking excels charting features
* hack formulas and functions move formulas around to deal with datatype issues, and improve recalculation time
* make the most of macros manage them and harness their power to extend other features
* use the enhanced capabilities of microsoft office 2007 to combine excel with word, access, and outlook.
Author : David hawley, raina hawley
Publication : Oreilly
Isbn : 9788184043518
Store book number : 105
NRS 640.00
|
|
|
|
|
|
|
|
|
|